package com.njitzx.mapper;

import com.njitzx.entity.po.Member;
import java.io.Serializable;
import java.util.List;

import com.njitzx.entity.vo.MemberVO;
import com.njitzx.entity.vo.SpMemberVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 会员表 Mapper 接口
 * </p>
 *
 * @author 周鑫
 * @since 2024-08-20
 */
@Mapper
public interface MemberMapper  {

    List<Member> select(Member member);

    MemberVO selectById(Serializable id);

    void insert(Member member);

    void update(Member member);

    void deleteById(Serializable id);

    void deleteByIds(List<Integer> split);

    void insertBatch(List<Member> list);

    @Select("SELECT  * FROM sp_member WHERE username=#{username}")
    Member selectByUername(String username);

    List<SpMemberVO> selectByPage(Member member);

    List<MemberVO> selectVO(Member member);

    int getCount();
}
